{ "cells": [ { "cell_type": "markdown", "id": "5873f971", "metadata": {}, "source": [ "![title](https://raw.githubusercontent.com/messari/messari-python-api/feature/demo_notebooks/examples/notebooks/images/defillama_messari_python.PNG)" ] }, { "cell_type": "markdown", "id": "b650d739", "metadata": {}, "source": [ "# DeFi Llama Python API Tutorial" ] }, { "cell_type": "markdown", "id": "90d1e1be", "metadata": {}, "source": [ "This tutorial aims to be a quick guide to get you started using the DeFi Llama API integrated into messari's python library." ] }, { "cell_type": "code", "execution_count": 1, "id": "4f68f0a5", "metadata": {}, "outputs": [], "source": [ "from messari.defillama import DeFiLlama\n", "dl = DeFiLlama()" ] }, { "cell_type": "markdown", "id": "ea4f2e3b", "metadata": {}, "source": [ "## API Structure" ] }, { "cell_type": "markdown", "id": "22c173a4", "metadata": {}, "source": [ "The Messari Python client contains a number of functions that wrap all of DeFi Llama's API endpoints. These include:\n", "\n", "* get_protocol_tvl_timeseries\n", "* get_global_tvl_timeseries\n", "* get_chain_tvl_timeseries\n", "* get_current_tvl\n", "* get_protocols\n", "\n", "Below are a few examples to showcase the functionality and types of data each function generates." ] }, { "cell_type": "markdown", "id": "d7e1db6b", "metadata": {}, "source": [ "## Get protocol tvl timeseries" ] }, { "cell_type": "markdown", "id": "5ccbe798", "metadata": {}, "source": [ "This function returns a timeseries of a protocol's TVL broken down by token amounts as a pandas DataFrame. The DataFrame uses a multiindex to group relevant data together following a convenient **df[protocol][chain][asset]** pattern. For example, the following code returns Aave's aggregate TVL and token amounts across all chains:" ] }, { "cell_type": "code", "execution_count": 9, "id": "6f8031a0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
totalLiquidityUSDZRXMANAUSDTWETHLENDDAIKNCLUNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)SUSD...REP_usdWMATIC_usdRENFIL_usdRAI_usdUSDP_usdAMPL_usdDPI_usdFRAX_usdFEI_usdWAVAX_usd
2021-10-011.272942e+105.263638e+066.243414e+061.796747e+082.391064e+06174907.2994797.078414e+08941804.295297NaN2.753281e+07...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-021.370309e+105.261857e+066.638973e+062.455208e+082.394438e+06174907.2994796.741214e+08940890.999608NaN2.544456e+07...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-031.416550e+105.264670e+069.217338e+062.275303e+082.403221e+06174907.2994796.703332e+08940890.999608NaN2.483117e+07...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-041.431796e+105.283455e+068.766940e+063.273912e+082.400876e+06174907.2994796.778497e+08925740.999608NaN2.256727e+07...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-051.478106e+105.283455e+068.812426e+063.380842e+082.452887e+06174907.2994797.292846e+08925740.999608NaN2.232785e+07...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

5 rows × 75 columns

\n", "
" ], "text/plain": [ " totalLiquidityUSD ZRX MANA USDT \\\n", "2021-10-01 1.272942e+10 5.263638e+06 6.243414e+06 1.796747e+08 \n", "2021-10-02 1.370309e+10 5.261857e+06 6.638973e+06 2.455208e+08 \n", "2021-10-03 1.416550e+10 5.264670e+06 9.217338e+06 2.275303e+08 \n", "2021-10-04 1.431796e+10 5.283455e+06 8.766940e+06 3.273912e+08 \n", "2021-10-05 1.478106e+10 5.283455e+06 8.812426e+06 3.380842e+08 \n", "\n", " WETH LEND DAI KNCL \\\n", "2021-10-01 2.391064e+06 174907.299479 7.078414e+08 941804.295297 \n", "2021-10-02 2.394438e+06 174907.299479 6.741214e+08 940890.999608 \n", "2021-10-03 2.403221e+06 174907.299479 6.703332e+08 940890.999608 \n", "2021-10-04 2.400876e+06 174907.299479 6.778497e+08 925740.999608 \n", "2021-10-05 2.452887e+06 174907.299479 7.292846e+08 925740.999608 \n", "\n", " UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862) \\\n", "2021-10-01 NaN \n", "2021-10-02 NaN \n", "2021-10-03 NaN \n", "2021-10-04 NaN \n", "2021-10-05 NaN \n", "\n", " SUSD ... REP_usd WMATIC_usd RENFIL_usd RAI_usd \\\n", "2021-10-01 2.753281e+07 ... NaN NaN NaN NaN \n", "2021-10-02 2.544456e+07 ... NaN NaN NaN NaN \n", "2021-10-03 2.483117e+07 ... NaN NaN NaN NaN \n", "2021-10-04 2.256727e+07 ... NaN NaN NaN NaN \n", "2021-10-05 2.232785e+07 ... NaN NaN NaN NaN \n", "\n", " USDP_usd AMPL_usd DPI_usd FRAX_usd FEI_usd WAVAX_usd \n", "2021-10-01 NaN NaN NaN NaN NaN NaN \n", "2021-10-02 NaN NaN NaN NaN NaN NaN \n", "2021-10-03 NaN NaN NaN NaN NaN NaN \n", "2021-10-04 NaN NaN NaN NaN NaN NaN \n", "2021-10-05 NaN NaN NaN NaN NaN NaN \n", "\n", "[5 rows x 75 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols = ['aave']\n", "protocol_tvls = dl.get_protocol_tvl_timeseries(protocols, start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n", "protocol_tvls['aave']['all'].head()" ] }, { "cell_type": "markdown", "id": "053e0785", "metadata": {}, "source": [ "We could narrow down our search by passing other supported chains as follows:" ] }, { "cell_type": "code", "execution_count": 4, "id": "ca2fffb1", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
aave
Avalanche...all
totalLiquidityUSDAAVEWBTCUSDTWETHUSDCWAVAXDAIAAVE_usdWBTC_usd...REP_usdWMATIC_usdRENFIL_usdRAI_usdUSDP_usdAMPL_usdDPI_usdFRAX_usdFEI_usdWAVAX_usd
2021-10-010.000000e+00NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-020.000000e+00NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-030.000000e+00NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-040.000000e+00NaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2021-10-056.226781e+08138168.3690272076.7256953.200520e+0761256.2127779.497521e+071.268147e+066.108483e+07NaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

5 rows × 176 columns

\n", "
" ], "text/plain": [ " aave \\\n", " Avalanche \n", " totalLiquidityUSD AAVE WBTC USDT \n", "2021-10-01 0.000000e+00 NaN NaN NaN \n", "2021-10-02 0.000000e+00 NaN NaN NaN \n", "2021-10-03 0.000000e+00 NaN NaN NaN \n", "2021-10-04 0.000000e+00 NaN NaN NaN \n", "2021-10-05 6.226781e+08 138168.369027 2076.725695 3.200520e+07 \n", "\n", " \\\n", " \n", " WETH USDC WAVAX DAI AAVE_usd \n", "2021-10-01 NaN NaN NaN NaN NaN \n", "2021-10-02 NaN NaN NaN NaN NaN \n", "2021-10-03 NaN NaN NaN NaN NaN \n", "2021-10-04 NaN NaN NaN NaN NaN \n", "2021-10-05 61256.212777 9.497521e+07 1.268147e+06 6.108483e+07 NaN \n", "\n", " ... \\\n", " ... all \n", " WBTC_usd ... REP_usd WMATIC_usd RENFIL_usd RAI_usd USDP_usd \n", "2021-10-01 NaN ... NaN NaN NaN NaN NaN \n", "2021-10-02 NaN ... NaN NaN NaN NaN NaN \n", "2021-10-03 NaN ... NaN NaN NaN NaN NaN \n", "2021-10-04 NaN ... NaN NaN NaN NaN NaN \n", "2021-10-05 NaN ... NaN NaN NaN NaN NaN \n", "\n", " \n", " \n", " AMPL_usd DPI_usd FRAX_usd FEI_usd WAVAX_usd \n", "2021-10-01 NaN NaN NaN NaN NaN \n", "2021-10-02 NaN NaN NaN NaN NaN \n", "2021-10-03 NaN NaN NaN NaN NaN \n", "2021-10-04 NaN NaN NaN NaN NaN \n", "2021-10-05 NaN NaN NaN NaN NaN \n", "\n", "[5 rows x 176 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocol_tvls.head()" ] }, { "cell_type": "markdown", "id": "7ae6bab7", "metadata": {}, "source": [ "To look at a protocol's aggregate TVL across all tokens of one specific chain, pass 'totalLiquidityUSD' as the asset index. For example, if we wanted to know Aave's total TVL in Ethereum, we would run:" ] }, { "cell_type": "code", "execution_count": 8, "id": "4c19665b", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[('Avalanche', 'totalLiquidityUSD'),\n", " ('Avalanche', 'AAVE'),\n", " ('Avalanche', 'WBTC'),\n", " ('Avalanche', 'USDT'),\n", " ('Avalanche', 'WETH'),\n", " ('Avalanche', 'USDC'),\n", " ('Avalanche', 'WAVAX'),\n", " ('Avalanche', 'DAI'),\n", " ('Avalanche', 'AAVE_usd'),\n", " ('Avalanche', 'WBTC_usd'),\n", " ('Avalanche', 'USDT_usd'),\n", " ('Avalanche', 'WETH_usd'),\n", " ('Avalanche', 'USDC_usd'),\n", " ('Avalanche', 'WAVAX_usd'),\n", " ('Avalanche', 'DAI_usd'),\n", " ('Polygon', 'totalLiquidityUSD'),\n", " ('Polygon', 'AAVE'),\n", " ('Polygon', 'WBTC'),\n", " ('Polygon', 'WMATIC'),\n", " ('Polygon', 'USDT'),\n", " ('Polygon', 'USDC'),\n", " ('Polygon', 'WETH'),\n", " ('Polygon', 'DAI'),\n", " ('Polygon', 'AAVE_usd'),\n", " ('Polygon', 'WBTC_usd'),\n", " ('Polygon', 'WMATIC_usd'),\n", " ('Polygon', 'USDT_usd'),\n", " ('Polygon', 'USDC_usd'),\n", " ('Polygon', 'WETH_usd'),\n", " ('Polygon', 'DAI_usd'),\n", " ('Ethereum', 'totalLiquidityUSD'),\n", " ('Ethereum', 'ZRX'),\n", " ('Ethereum', 'MANA'),\n", " ('Ethereum', 'USDT'),\n", " ('Ethereum', 'WETH'),\n", " ('Ethereum', 'LEND'),\n", " ('Ethereum', 'DAI'),\n", " ('Ethereum', 'KNCL'),\n", " ('Ethereum', 'UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)'),\n", " ('Ethereum', 'SUSD'),\n", " ('Ethereum', 'TUSD'),\n", " ('Ethereum', 'BAT'),\n", " ('Ethereum', 'MKR'),\n", " ('Ethereum', 'LINK'),\n", " ('Ethereum', 'USDC'),\n", " ('Ethereum', 'SNX'),\n", " ('Ethereum', 'WBTC'),\n", " ('Ethereum', 'BUSD'),\n", " ('Ethereum', 'SETH'),\n", " ('Ethereum', 'ENJ'),\n", " ('Ethereum', 'REN'),\n", " ('Ethereum', 'YFI'),\n", " ('Ethereum', 'AAVE'),\n", " ('Ethereum', 'UNI'),\n", " ('Ethereum', 'CRV'),\n", " ('Ethereum', 'GUSD'),\n", " ('Ethereum', 'BAL'),\n", " ('Ethereum', 'XSUSHI'),\n", " ('Ethereum', 'REP'),\n", " ('Ethereum', 'RENFIL'),\n", " ('Ethereum', 'RAI'),\n", " ('Ethereum', 'USDP'),\n", " ('Ethereum', 'AMPL'),\n", " ('Ethereum', 'DPI'),\n", " ('Ethereum', 'FRAX'),\n", " ('Ethereum', 'FEI'),\n", " ('Ethereum', 'ZRX_usd'),\n", " ('Ethereum', 'MANA_usd'),\n", " ('Ethereum', 'USDT_usd'),\n", " ('Ethereum', 'WETH_usd'),\n", " ('Ethereum', 'LEND_usd'),\n", " ('Ethereum', 'DAI_usd'),\n", " ('Ethereum', 'KNCL_usd'),\n", " ('Ethereum', 'UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd'),\n", " ('Ethereum', 'SUSD_usd'),\n", " ('Ethereum', 'TUSD_usd'),\n", " ('Ethereum', 'BAT_usd'),\n", " ('Ethereum', 'MKR_usd'),\n", " ('Ethereum', 'LINK_usd'),\n", " ('Ethereum', 'USDC_usd'),\n", " ('Ethereum', 'SNX_usd'),\n", " ('Ethereum', 'WBTC_usd'),\n", " ('Ethereum', 'BUSD_usd'),\n", " ('Ethereum', 'SETH_usd'),\n", " ('Ethereum', 'ENJ_usd'),\n", " ('Ethereum', 'REN_usd'),\n", " ('Ethereum', 'YFI_usd'),\n", " ('Ethereum', 'AAVE_usd'),\n", " ('Ethereum', 'UNI_usd'),\n", " ('Ethereum', 'CRV_usd'),\n", " ('Ethereum', 'GUSD_usd'),\n", " ('Ethereum', 'BAL_usd'),\n", " ('Ethereum', 'XSUSHI_usd'),\n", " ('Ethereum', 'REP_usd'),\n", " ('Ethereum', 'RENFIL_usd'),\n", " ('Ethereum', 'RAI_usd'),\n", " ('Ethereum', 'USDP_usd'),\n", " ('Ethereum', 'AMPL_usd'),\n", " ('Ethereum', 'DPI_usd'),\n", " ('Ethereum', 'FRAX_usd'),\n", " ('Ethereum', 'FEI_usd'),\n", " ('all', 'totalLiquidityUSD'),\n", " ('all', 'ZRX'),\n", " ('all', 'MANA'),\n", " ('all', 'USDT'),\n", " ('all', 'WETH'),\n", " ('all', 'LEND'),\n", " ('all', 'DAI'),\n", " ('all', 'KNCL'),\n", " ('all', 'UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)'),\n", " ('all', 'SUSD'),\n", " ('all', 'TUSD'),\n", " ('all', 'BAT'),\n", " ('all', 'MKR'),\n", " ('all', 'LINK'),\n", " ('all', 'USDC'),\n", " ('all', 'SNX'),\n", " ('all', 'WBTC'),\n", " ('all', 'BUSD'),\n", " ('all', 'SETH'),\n", " ('all', 'ENJ'),\n", " ('all', 'REN'),\n", " ('all', 'YFI'),\n", " ('all', 'AAVE'),\n", " ('all', 'UNI'),\n", " ('all', 'CRV'),\n", " ('all', 'GUSD'),\n", " ('all', 'BAL'),\n", " ('all', 'XSUSHI'),\n", " ('all', 'REP'),\n", " ('all', 'WMATIC'),\n", " ('all', 'RENFIL'),\n", " ('all', 'RAI'),\n", " ('all', 'USDP'),\n", " ('all', 'AMPL'),\n", " ('all', 'DPI'),\n", " ('all', 'FRAX'),\n", " ('all', 'FEI'),\n", " ('all', 'WAVAX'),\n", " ('all', 'ZRX_usd'),\n", " ('all', 'MANA_usd'),\n", " ('all', 'USDT_usd'),\n", " ('all', 'WETH_usd'),\n", " ('all', 'LEND_usd'),\n", " ('all', 'DAI_usd'),\n", " ('all', 'KNCL_usd'),\n", " ('all', 'UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd'),\n", " ('all', 'SUSD_usd'),\n", " ('all', 'TUSD_usd'),\n", " ('all', 'BAT_usd'),\n", " ('all', 'MKR_usd'),\n", " ('all', 'LINK_usd'),\n", " ('all', 'USDC_usd'),\n", " ('all', 'SNX_usd'),\n", " ('all', 'WBTC_usd'),\n", " ('all', 'BUSD_usd'),\n", " ('all', 'SETH_usd'),\n", " ('all', 'ENJ_usd'),\n", " ('all', 'REN_usd'),\n", " ('all', 'YFI_usd'),\n", " ('all', 'AAVE_usd'),\n", " ('all', 'UNI_usd'),\n", " ('all', 'CRV_usd'),\n", " ('all', 'GUSD_usd'),\n", " ('all', 'BAL_usd'),\n", " ('all', 'XSUSHI_usd'),\n", " ('all', 'REP_usd'),\n", " ('all', 'WMATIC_usd'),\n", " ('all', 'RENFIL_usd'),\n", " ('all', 'RAI_usd'),\n", " ('all', 'USDP_usd'),\n", " ('all', 'AMPL_usd'),\n", " ('all', 'DPI_usd'),\n", " ('all', 'FRAX_usd'),\n", " ('all', 'FEI_usd'),\n", " ('all', 'WAVAX_usd')]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "list(protocol_tvls['aave'].columns)" ] }, { "cell_type": "markdown", "id": "15679fd7", "metadata": {}, "source": [ "## Get global tvl timeseries" ] }, { "cell_type": "markdown", "id": "2634f698", "metadata": {}, "source": [ "This function returns a timeseries of aggregate TVL across all supported protocols in DeFi Llama as a pandas DataFrame" ] }, { "cell_type": "code", "execution_count": 3, "id": "29537de4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
totalLiquidityUSD
2021-10-011.931929e+11
2021-10-021.975269e+11
2021-10-032.000398e+11
2021-10-042.010004e+11
2021-10-052.052809e+11
2021-10-062.050247e+11
2021-10-072.074607e+11
2021-10-082.110497e+11
2021-10-092.116465e+11
2021-10-102.129363e+11
\n", "
" ], "text/plain": [ " totalLiquidityUSD\n", "2021-10-01 1.931929e+11\n", "2021-10-02 1.975269e+11\n", "2021-10-03 2.000398e+11\n", "2021-10-04 2.010004e+11\n", "2021-10-05 2.052809e+11\n", "2021-10-06 2.050247e+11\n", "2021-10-07 2.074607e+11\n", "2021-10-08 2.110497e+11\n", "2021-10-09 2.116465e+11\n", "2021-10-10 2.129363e+11" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "global_tvl = dl.get_global_tvl_timeseries(start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n", "global_tvl" ] }, { "cell_type": "markdown", "id": "45251120", "metadata": {}, "source": [ "## Get chain tvl timeseries" ] }, { "cell_type": "markdown", "id": "df853435", "metadata": {}, "source": [ "This function retrives timeseries TVL for a given chain or list of chains as a pandas DataFrame" ] }, { "cell_type": "code", "execution_count": 5, "id": "7730b74d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AvalancheHarmonyPolygon
2021-10-013.763324e+091.350100e+084.342970e+09
2021-10-024.001220e+091.399944e+084.527419e+09
2021-10-034.071999e+091.500492e+084.659061e+09
2021-10-043.870700e+091.497508e+084.658624e+09
2021-10-054.126030e+091.553020e+084.706019e+09
2021-10-064.523881e+091.534946e+084.739420e+09
2021-10-074.509480e+091.577545e+084.713894e+09
2021-10-084.522813e+091.645999e+084.647436e+09
2021-10-095.040974e+091.935887e+084.477904e+09
2021-10-105.131507e+091.875108e+084.456939e+09
\n", "
" ], "text/plain": [ " Avalanche Harmony Polygon\n", "2021-10-01 3.763324e+09 1.350100e+08 4.342970e+09\n", "2021-10-02 4.001220e+09 1.399944e+08 4.527419e+09\n", "2021-10-03 4.071999e+09 1.500492e+08 4.659061e+09\n", "2021-10-04 3.870700e+09 1.497508e+08 4.658624e+09\n", "2021-10-05 4.126030e+09 1.553020e+08 4.706019e+09\n", "2021-10-06 4.523881e+09 1.534946e+08 4.739420e+09\n", "2021-10-07 4.509480e+09 1.577545e+08 4.713894e+09\n", "2021-10-08 4.522813e+09 1.645999e+08 4.647436e+09\n", "2021-10-09 5.040974e+09 1.935887e+08 4.477904e+09\n", "2021-10-10 5.131507e+09 1.875108e+08 4.456939e+09" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "chains = [\"Avalanche\", \"Harmony\", \"Polygon\"]\n", "chain_tvls = dl.get_chain_tvl_timeseries(chains, start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n", "chain_tvls" ] }, { "cell_type": "markdown", "id": "9b4d6ef3", "metadata": {}, "source": [ "## Get current tvl" ] }, { "cell_type": "markdown", "id": "31e6bad8", "metadata": {}, "source": [ "The function retrives the current protocol tvl as a pandas DataFrame for an asset or list of assets" ] }, { "cell_type": "code", "execution_count": 8, "id": "b47f7d00", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
tvl
uniswap1.040976e+10
curve2.041504e+10
aave1.541991e+10
\n", "
" ], "text/plain": [ " tvl\n", "uniswap 1.040976e+10\n", "curve 2.041504e+10\n", "aave 1.541991e+10" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols = [\"uniswap\", \"curve\", \"aave\"]\n", "current_tvl = dl.get_current_tvl(protocols)\n", "current_tvl" ] }, { "cell_type": "markdown", "id": "fe248c35", "metadata": {}, "source": [ "## Get protocols" ] }, { "cell_type": "markdown", "id": "d7c6dfcd", "metadata": {}, "source": [ "The function returns basic information on all DeFi Llama listed protocols." ] }, { "cell_type": "code", "execution_count": 2, "id": "cd30a18b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
curveconvex-financemakerdaoaavepolygon-bridge-&-stakinglidowbtcinstadappanchorcompound...one-cashstand-cashpurefioptidogewisteria-swaplouverturekawaiiswapvalkyrieumbrella-networkcyclos
id33191181112401822120294114...1094109510961102111111181128113811531156
nameCurveConvex FinanceMakerDAOAAVEPolygon Bridge & StakingLidoWBTCInstadappAnchorCompound...One CashStand CashPureFiOptidogeWisteria SwapLouvertureKawaiiSwapValkyrieUmbrella NetworkCyclos
address0xD533a949740bb3306d119CC777fa900bA034cd520x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b0x9f8f72aa9304c8b593d555f12ef6589cc3a579a20x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae90x7d1afa7b718fb893db30a3abc0cfc608aacfebb00x5a98fcbea516cf06857215779fd812ca3bef1b320x2260fac5e5542a773aa44fbcfedf7c193bc2c5990x6f40d4a6237c257fff2db00fa0510deeecd303eb-0xc00e94cb662c3520282e6f5717214004a7f26888...0xd90e69f67203ebe02c917b5128629e77b4cd92dc0xacd8f2523a4613eee78904354187c81bb05ae2b8bsc:0xe2a59d5e33c6540e18aaa46bf98917ac3158db0doptimism:0x93D97dbB1BB5290C78C23885E8026047dC8...bsc:0xaadff17d56d80312b392ced903f3e8dbe5c3ece7avax:0xff579d6259dEDcc80488c9b89d2820bCb5609160bsc:0x9e236b43D779B385c3279820e322ABAE249D3405terra:terra1dy9kmlm4anr92e42mrkjwzyvfqwz66un00...0x6fC13EACE26590B80cCCAB1ba5d51890577D83B2solana:BRLsMczKuaR5w9vSubF4j8HwEGGprVAyyVgS4EX...
symbolCRVCVXMKRAAVEMATICLDOWBTCINSTANCCOMP...ONCSACUFIOPTIDOGEWSTLVTCALCIFIREVKRUMBCYS
urlhttps://curve.fihttps://www.convexfinance.com/https://makerdao.com/https://aave.com\\r\\nhttps://polygon.technology/https://lido.fi/https://wbtc.network/https://instadapp.io/https://anchorprotocol.com/https://compound.finance...https://onecash.finance/https://stand.cash/https://www.purefi.iohttps://optidoge.xyz/https://wisteriaswap.comhttps://www.louverture.finance/https://www.kawaiiswap.finance/https://valkyrieprotocol.comhttps://staking.umb.networkhttps://cyclos.io
descriptionCurve is a decentralized exchange liquidity po...Convex simplifies your Curve-boosting experien...Builders of Dai, a digital currency that can b...Aave is an Open Source and Non-Custodial proto...Ethereum sidechain\\r\\nLiquidity for staked assets. Daily rewards, no...Wrapped Bitcoin (WBTC) is the first ERC20 toke...Aims to drive interoperability between protoco...Money market on TerraCompound is an algorithmic, autonomous interes......Staking protocol on ethereum networkNonePureFi — one-stop compliance protocol for dece...Optimism Dog tokenWisteriaSwap is a new DeFi 2.0 (PVC) model tha...The Opening of your yields across different ch...KawaiiSwap enrichs traditional yield farming e...Valkyrie Protocol is a DApp activation protoco...Umbrella is the first truly decentralized orac...The 1st concentrated liquidity market maker on...
chainMulti-ChainEthereumEthereumMulti-ChainPolygonMulti-ChainEthereumEthereumTerraEthereum...EthereumEthereumEthereumOptimismBinanceAvalancheBinanceTerraMulti-ChainSolana
logohttps://icons.llama.fi/curve.pnghttps://icons.llama.fi/convex-finance.jpghttps://icons.llama.fi/makerdao.jpghttps://icons.llama.fi/aave.pnghttps://icons.llama.fi/polygon.jpghttps://icons.llama.fi/lido.pnghttps://icons.llama.fi/wbtc.pnghttps://icons.llama.fi/instadapp.jpghttps://icons.llama.fi/anchor.jpghttps://icons.llama.fi/compound.png...https://icons.llama.fi/onecash.pnghttps://icons.llama.fi/standcash.pnghttps://icons.llama.fi/purefi.pnghttps://icons.llama.fi/optidoge.pnghttps://icons.llama.fi/wisteriaswap.pnghttps://icons.llama.fi/louverture.jpghttps://icons.llama.fi/kawaiiswap.pnghttps://icons.llama.fi/valkyrie.pnghttps://icons.llama.fi/umbrella-network.jpghttps://icons.llama.fi/cyclos.png
audits2222022None22...0020202200
audit_noteNoneNoneNoneNoneNoneNoneNoneNoneNoneNone...NoneNoneNoneNoneNoneNoneNoneNoneNoneNone
gecko_idcurve-dao-tokenconvex-financemakeraavematic-networklido-daowrapped-bitcoininstadappanchor-protocolcompound-governance-token...one-cashstand-cashpurefiNonewisteria-swaplouvertureNonevalkyrie-protocolumbrella-networkcyclos
cmcId65389903151872783890800037171050888575692...8159None10973None16289NoneNone12978838510217
categoryDexesYieldMintingLendingChainStakingBridgeServicesLendingLending...StakingYieldStakingYieldYieldYieldYieldStakingStakingDexes
chains[Ethereum, Avalanche, Fantom, Arbitrum, Polygo...[Ethereum][Ethereum][Ethereum, Avalanche, Polygon][Polygon][Ethereum, Terra, Solana][Ethereum][Ethereum][Terra][Ethereum]...[Ethereum][Ethereum][Ethereum][Optimism][Binance][Avalanche][Binance][Terra][Binance, Ethereum][Solana]
modulecurve/index.jsconvex/index.jsmaker/index.jsaave/index.jspolygon/index.jslido/index.jswbtc.jsinstadapp.jsanchor/index.jscompound-onchain/index.js...onecash/index.jsstandcash/index.jspurefi/index.jsoptidoge/index.jswisteriaswap/index.jslouverture/index.jskawaiiswap-finance/index.jsvalkyrie/index.jsumbrella/index.jscyclos/index.js
twitterCurveFinanceConvexFinanceMakerDAOAaveAave0xPolygonLidoFinanceWrappedBTCInstadappanchor_protocolcompoundfinance...NoneNonePurefi_ProtocolNaNrobiniaswapLouverture_fikawaiiswapvalkyrie_moneyUmbNetworkcyclosfi
audit_links[https://curve.fi/audits][https://github.com/convex-eth/platform/blob/m...[https://security.makerdao.com/][https://aave.com/security]NaN[https://github.com/lidofinance/audits][https://wbtc.network/dashboard/audit][https://github.com/Instadapp/dsa-contracts/bl...[https://docs.anchorprotocol.com/security#audits][https://compound.finance/docs/security]...NaNNaN[https://www.purefi.io/files/27072021_PureFi_A...NaN[https://github.com/TechRate/Smart-Contract-Au...NaN[https://github.com/solidproof/smart-contract-...[https://docs.valkyrieprotocol.com/security#au...NaNNaN
oracles[Chainlink]NaN[Maker][Chainlink]NaNNaN[Chainlink]NaNNaN[Chainlink]...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
slugcurveconvex-financemakerdaoaavepolygon-bridge-&-stakinglidowbtcinstadappanchorcompound...one-cashstand-cashpurefioptidogewisteria-swaplouverturekawaiiswapvalkyrieumbrella-networkcyclos
tvl24112003053.33387820639232629.40715417960975704.53141814422567161.8482813915459919.24552312594153819.63078912064003348.199999108378267179235398690.890278867725872.200926...0000000000
chainTvls{'Avalanche': 1285006817.5135474, 'Harmony': 1...{'Ethereum': 20639232629.407154}{'Ethereum': 17960975704.531418}{'pool2': 326533773.79811203, 'Avalanche': 318...{'Polygon': 13915459919.245523}{'Ethereum': 6194879349.377187, 'Solana': 2196...{'Ethereum': 12064003348.199999}{'Ethereum': 10837826717}{'Terra-borrowed': 2068288947.989085, 'Terra':...{'Ethereum': 8867725872.200926, 'Ethereum-borr......{'Ethereum': 0, 'pool2': 43124.89514303551, 'E...{'Ethereum': 0, 'pool2': 423016.41161172936, '...{'Ethereum': 0, 'Ethereum-staking': 3153838.64...{'Optimism': 0, 'Optimism-pool2': 7.9520316345...{'Binance-Masterchef': 0, 'pool2': 0, 'Masterc...{'Avalanche-staking': 13144900.117367093, 'Ava...{'Binance-Masterchef': 0, 'pool2': 26024.31075...{'Terra-staking': 12147179.037418013, 'pool2':...{'Binance-staking': 1739.42715, 'pool2': 23718...{'Solana-staking': 1573970.9193507198, 'Solana...
change_1h0.224810.2218510.1993980.440074-0.1099151.0618320.348118-0.3241680.997076-0.903851...NoneNoneNoneNoneNoneNoneNoneNoneNoneNone
change_1d0.338020.271311-0.771607-0.715227-2.0718061.427736-1.4621590.3629962.638964-0.972276...NoneNoneNoneNoneNoneNoneNoneNoneNoneNone
change_7d2.6538886.310743-6.59762-7.602423-7.266393-3.791608-10.295178-3.0185383.037275-12.394381...NoneNoneNoneNoneNoneNoneNoneNoneNoneNone
staking2500230590.786564NaNNaN790518716.472052NaNNaNNaNNaNNaNNaN...87591.59085229172.9523273153838.64467410741.36223813386599.02052913144900.11736778995.65995612147179.03741814885084.1934861573970.919351
fdv2122770696846791812262447142707432567244824639309394333247878012073482278NaN34983259072179122291...3953265684.0313157656NaNNaN5859185NaN34738419713459973595370304
mcap25190116122086330311219340389736405269361693432671922166730712073482278532544456694991401375137351...3953264205.873070174NaN00NaN298803263278106111093474
pool2NaNNaNNaN326533773.798112NaNNaNNaNNaNNaNNaN...43124.895143423016.411612NaN7.9520320NaN26024.31075912264447.9321482371866.839791NaN
forkedFromNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaN[ArbiNyan]NaNNaNNaNNaNNaNNaN
listedAtNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...1640525223164052522316405252231640596078164063121316406918321640719202164073867416408291151640830327
auditNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
audits_linkNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

32 rows × 1033 columns

\n", "
" ], "text/plain": [ " curve \\\n", "id 3 \n", "name Curve \n", "address 0xD533a949740bb3306d119CC777fa900bA034cd52 \n", "symbol CRV \n", "url https://curve.fi \n", "description Curve is a decentralized exchange liquidity po... \n", "chain Multi-Chain \n", "logo https://icons.llama.fi/curve.png \n", "audits 2 \n", "audit_note None \n", "gecko_id curve-dao-token \n", "cmcId 6538 \n", "category Dexes \n", "chains [Ethereum, Avalanche, Fantom, Arbitrum, Polygo... \n", "module curve/index.js \n", "twitter CurveFinance \n", "audit_links [https://curve.fi/audits] \n", "oracles [Chainlink] \n", "slug curve \n", "tvl 24112003053.333878 \n", "chainTvls {'Avalanche': 1285006817.5135474, 'Harmony': 1... \n", "change_1h 0.22481 \n", "change_1d 0.33802 \n", "change_7d 2.653888 \n", "staking 2500230590.786564 \n", "fdv 21227706968 \n", "mcap 2519011612 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " convex-finance \\\n", "id 319 \n", "name Convex Finance \n", "address 0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b \n", "symbol CVX \n", "url https://www.convexfinance.com/ \n", "description Convex simplifies your Curve-boosting experien... \n", "chain Ethereum \n", "logo https://icons.llama.fi/convex-finance.jpg \n", "audits 2 \n", "audit_note None \n", "gecko_id convex-finance \n", "cmcId 9903 \n", "category Yield \n", "chains [Ethereum] \n", "module convex/index.js \n", "twitter ConvexFinance \n", "audit_links [https://github.com/convex-eth/platform/blob/m... \n", "oracles NaN \n", "slug convex-finance \n", "tvl 20639232629.407154 \n", "chainTvls {'Ethereum': 20639232629.407154} \n", "change_1h 0.221851 \n", "change_1d 0.271311 \n", "change_7d 6.310743 \n", "staking NaN \n", "fdv 4679181226 \n", "mcap 2086330311 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " makerdao \\\n", "id 118 \n", "name MakerDAO \n", "address 0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2 \n", "symbol MKR \n", "url https://makerdao.com/ \n", "description Builders of Dai, a digital currency that can b... \n", "chain Ethereum \n", "logo https://icons.llama.fi/makerdao.jpg \n", "audits 2 \n", "audit_note None \n", "gecko_id maker \n", "cmcId 1518 \n", "category Minting \n", "chains [Ethereum] \n", "module maker/index.js \n", "twitter MakerDAO \n", "audit_links [https://security.makerdao.com/] \n", "oracles [Maker] \n", "slug makerdao \n", "tvl 17960975704.531418 \n", "chainTvls {'Ethereum': 17960975704.531418} \n", "change_1h 0.199398 \n", "change_1d -0.771607 \n", "change_7d -6.59762 \n", "staking NaN \n", "fdv 2447142707 \n", "mcap 2193403897 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " aave \\\n", "id 111 \n", "name AAVE \n", "address 0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9 \n", "symbol AAVE \n", "url https://aave.com\\r\\n \n", "description Aave is an Open Source and Non-Custodial proto... \n", "chain Multi-Chain \n", "logo https://icons.llama.fi/aave.png \n", "audits 2 \n", "audit_note None \n", "gecko_id aave \n", "cmcId 7278 \n", "category Lending \n", "chains [Ethereum, Avalanche, Polygon] \n", "module aave/index.js \n", "twitter AaveAave \n", "audit_links [https://aave.com/security] \n", "oracles [Chainlink] \n", "slug aave \n", "tvl 14422567161.84828 \n", "chainTvls {'pool2': 326533773.79811203, 'Avalanche': 318... \n", "change_1h 0.440074 \n", "change_1d -0.715227 \n", "change_7d -7.602423 \n", "staking 790518716.472052 \n", "fdv 4325672448 \n", "mcap 3640526936 \n", "pool2 326533773.798112 \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " polygon-bridge-&-staking \\\n", "id 240 \n", "name Polygon Bridge & Staking \n", "address 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 \n", "symbol MATIC \n", "url https://polygon.technology/ \n", "description Ethereum sidechain\\r\\n \n", "chain Polygon \n", "logo https://icons.llama.fi/polygon.jpg \n", "audits 0 \n", "audit_note None \n", "gecko_id matic-network \n", "cmcId 3890 \n", "category Chain \n", "chains [Polygon] \n", "module polygon/index.js \n", "twitter 0xPolygon \n", "audit_links NaN \n", "oracles NaN \n", "slug polygon-bridge-&-staking \n", "tvl 13915459919.245523 \n", "chainTvls {'Polygon': 13915459919.245523} \n", "change_1h -0.109915 \n", "change_1d -2.071806 \n", "change_7d -7.266393 \n", "staking NaN \n", "fdv 24639309394 \n", "mcap 16934326719 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " lido \\\n", "id 182 \n", "name Lido \n", "address 0x5a98fcbea516cf06857215779fd812ca3bef1b32 \n", "symbol LDO \n", "url https://lido.fi/ \n", "description Liquidity for staked assets. Daily rewards, no... \n", "chain Multi-Chain \n", "logo https://icons.llama.fi/lido.png \n", "audits 2 \n", "audit_note None \n", "gecko_id lido-dao \n", "cmcId 8000 \n", "category Staking \n", "chains [Ethereum, Terra, Solana] \n", "module lido/index.js \n", "twitter LidoFinance \n", "audit_links [https://github.com/lidofinance/audits] \n", "oracles NaN \n", "slug lido \n", "tvl 12594153819.630789 \n", "chainTvls {'Ethereum': 6194879349.377187, 'Solana': 2196... \n", "change_1h 1.061832 \n", "change_1d 1.427736 \n", "change_7d -3.791608 \n", "staking NaN \n", "fdv 3332478780 \n", "mcap 221667307 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " wbtc \\\n", "id 2 \n", "name WBTC \n", "address 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 \n", "symbol WBTC \n", "url https://wbtc.network/ \n", "description Wrapped Bitcoin (WBTC) is the first ERC20 toke... \n", "chain Ethereum \n", "logo https://icons.llama.fi/wbtc.png \n", "audits 2 \n", "audit_note None \n", "gecko_id wrapped-bitcoin \n", "cmcId 3717 \n", "category Bridge \n", "chains [Ethereum] \n", "module wbtc.js \n", "twitter WrappedBTC \n", "audit_links [https://wbtc.network/dashboard/audit] \n", "oracles [Chainlink] \n", "slug wbtc \n", "tvl 12064003348.199999 \n", "chainTvls {'Ethereum': 12064003348.199999} \n", "change_1h 0.348118 \n", "change_1d -1.462159 \n", "change_7d -10.295178 \n", "staking NaN \n", "fdv 12073482278 \n", "mcap 12073482278 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " instadapp \\\n", "id 120 \n", "name Instadapp \n", "address 0x6f40d4a6237c257fff2db00fa0510deeecd303eb \n", "symbol INST \n", "url https://instadapp.io/ \n", "description Aims to drive interoperability between protoco... \n", "chain Ethereum \n", "logo https://icons.llama.fi/instadapp.jpg \n", "audits None \n", "audit_note None \n", "gecko_id instadapp \n", "cmcId 10508 \n", "category Services \n", "chains [Ethereum] \n", "module instadapp.js \n", "twitter Instadapp \n", "audit_links [https://github.com/Instadapp/dsa-contracts/bl... \n", "oracles NaN \n", "slug instadapp \n", "tvl 10837826717 \n", "chainTvls {'Ethereum': 10837826717} \n", "change_1h -0.324168 \n", "change_1d 0.362996 \n", "change_7d -3.018538 \n", "staking NaN \n", "fdv NaN \n", "mcap 53254445 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " anchor \\\n", "id 294 \n", "name Anchor \n", "address - \n", "symbol ANC \n", "url https://anchorprotocol.com/ \n", "description Money market on Terra \n", "chain Terra \n", "logo https://icons.llama.fi/anchor.jpg \n", "audits 2 \n", "audit_note None \n", "gecko_id anchor-protocol \n", "cmcId 8857 \n", "category Lending \n", "chains [Terra] \n", "module anchor/index.js \n", "twitter anchor_protocol \n", "audit_links [https://docs.anchorprotocol.com/security#audits] \n", "oracles NaN \n", "slug anchor \n", "tvl 9235398690.89027 \n", "chainTvls {'Terra-borrowed': 2068288947.989085, 'Terra':... \n", "change_1h 0.997076 \n", "change_1d 2.638964 \n", "change_7d 3.037275 \n", "staking NaN \n", "fdv 3498325907 \n", "mcap 669499140 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt NaN \n", "audit NaN \n", "audits_link NaN \n", "\n", " compound ... \\\n", "id 114 ... \n", "name Compound ... \n", "address 0xc00e94cb662c3520282e6f5717214004a7f26888 ... \n", "symbol COMP ... \n", "url https://compound.finance ... \n", "description Compound is an algorithmic, autonomous interes... ... \n", "chain Ethereum ... \n", "logo https://icons.llama.fi/compound.png ... \n", "audits 2 ... \n", "audit_note None ... \n", "gecko_id compound-governance-token ... \n", "cmcId 5692 ... \n", "category Lending ... \n", "chains [Ethereum] ... \n", "module compound-onchain/index.js ... \n", "twitter compoundfinance ... \n", "audit_links [https://compound.finance/docs/security] ... \n", "oracles [Chainlink] ... \n", "slug compound ... \n", "tvl 8867725872.200926 ... \n", "chainTvls {'Ethereum': 8867725872.200926, 'Ethereum-borr... ... \n", "change_1h -0.903851 ... \n", "change_1d -0.972276 ... \n", "change_7d -12.394381 ... \n", "staking NaN ... \n", "fdv 2179122291 ... \n", "mcap 1375137351 ... \n", "pool2 NaN ... \n", "forkedFrom NaN ... \n", "listedAt NaN ... \n", "audit NaN ... \n", "audits_link NaN ... \n", "\n", " one-cash \\\n", "id 1094 \n", "name One Cash \n", "address 0xd90e69f67203ebe02c917b5128629e77b4cd92dc \n", "symbol ONC \n", "url https://onecash.finance/ \n", "description Staking protocol on ethereum network \n", "chain Ethereum \n", "logo https://icons.llama.fi/onecash.png \n", "audits 0 \n", "audit_note None \n", "gecko_id one-cash \n", "cmcId 8159 \n", "category Staking \n", "chains [Ethereum] \n", "module onecash/index.js \n", "twitter None \n", "audit_links NaN \n", "oracles NaN \n", "slug one-cash \n", "tvl 0 \n", "chainTvls {'Ethereum': 0, 'pool2': 43124.89514303551, 'E... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 87591.590852 \n", "fdv 395326 \n", "mcap 395326 \n", "pool2 43124.895143 \n", "forkedFrom NaN \n", "listedAt 1640525223 \n", "audit NaN \n", "audits_link NaN \n", "\n", " stand-cash \\\n", "id 1095 \n", "name Stand Cash \n", "address 0xacd8f2523a4613eee78904354187c81bb05ae2b8 \n", "symbol SAC \n", "url https://stand.cash/ \n", "description None \n", "chain Ethereum \n", "logo https://icons.llama.fi/standcash.png \n", "audits 0 \n", "audit_note None \n", "gecko_id stand-cash \n", "cmcId None \n", "category Yield \n", "chains [Ethereum] \n", "module standcash/index.js \n", "twitter None \n", "audit_links NaN \n", "oracles NaN \n", "slug stand-cash \n", "tvl 0 \n", "chainTvls {'Ethereum': 0, 'pool2': 423016.41161172936, '... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 29172.952327 \n", "fdv 5684.03 \n", "mcap 4205.87 \n", "pool2 423016.411612 \n", "forkedFrom NaN \n", "listedAt 1640525223 \n", "audit NaN \n", "audits_link NaN \n", "\n", " purefi \\\n", "id 1096 \n", "name PureFi \n", "address bsc:0xe2a59d5e33c6540e18aaa46bf98917ac3158db0d \n", "symbol UFI \n", "url https://www.purefi.io \n", "description PureFi — one-stop compliance protocol for dece... \n", "chain Ethereum \n", "logo https://icons.llama.fi/purefi.png \n", "audits 2 \n", "audit_note None \n", "gecko_id purefi \n", "cmcId 10973 \n", "category Staking \n", "chains [Ethereum] \n", "module purefi/index.js \n", "twitter Purefi_Protocol \n", "audit_links [https://www.purefi.io/files/27072021_PureFi_A... \n", "oracles NaN \n", "slug purefi \n", "tvl 0 \n", "chainTvls {'Ethereum': 0, 'Ethereum-staking': 3153838.64... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 3153838.644674 \n", "fdv 13157656 \n", "mcap 3070174 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt 1640525223 \n", "audit NaN \n", "audits_link NaN \n", "\n", " optidoge \\\n", "id 1102 \n", "name Optidoge \n", "address optimism:0x93D97dbB1BB5290C78C23885E8026047dC8... \n", "symbol OPTIDOGE \n", "url https://optidoge.xyz/ \n", "description Optimism Dog token \n", "chain Optimism \n", "logo https://icons.llama.fi/optidoge.png \n", "audits 0 \n", "audit_note None \n", "gecko_id None \n", "cmcId None \n", "category Yield \n", "chains [Optimism] \n", "module optidoge/index.js \n", "twitter NaN \n", "audit_links NaN \n", "oracles NaN \n", "slug optidoge \n", "tvl 0 \n", "chainTvls {'Optimism': 0, 'Optimism-pool2': 7.9520316345... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 10741.362238 \n", "fdv NaN \n", "mcap NaN \n", "pool2 7.952032 \n", "forkedFrom [ArbiNyan] \n", "listedAt 1640596078 \n", "audit NaN \n", "audits_link NaN \n", "\n", " wisteria-swap \\\n", "id 1111 \n", "name Wisteria Swap \n", "address bsc:0xaadff17d56d80312b392ced903f3e8dbe5c3ece7 \n", "symbol WST \n", "url https://wisteriaswap.com \n", "description WisteriaSwap is a new DeFi 2.0 (PVC) model tha... \n", "chain Binance \n", "logo https://icons.llama.fi/wisteriaswap.png \n", "audits 2 \n", "audit_note None \n", "gecko_id wisteria-swap \n", "cmcId 16289 \n", "category Yield \n", "chains [Binance] \n", "module wisteriaswap/index.js \n", "twitter robiniaswap \n", "audit_links [https://github.com/TechRate/Smart-Contract-Au... \n", "oracles NaN \n", "slug wisteria-swap \n", "tvl 0 \n", "chainTvls {'Binance-Masterchef': 0, 'pool2': 0, 'Masterc... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 13386599.020529 \n", "fdv NaN \n", "mcap 0 \n", "pool2 0 \n", "forkedFrom NaN \n", "listedAt 1640631213 \n", "audit NaN \n", "audits_link NaN \n", "\n", " louverture \\\n", "id 1118 \n", "name Louverture \n", "address avax:0xff579d6259dEDcc80488c9b89d2820bCb5609160 \n", "symbol LVT \n", "url https://www.louverture.finance/ \n", "description The Opening of your yields across different ch... \n", "chain Avalanche \n", "logo https://icons.llama.fi/louverture.jpg \n", "audits 0 \n", "audit_note None \n", "gecko_id louverture \n", "cmcId None \n", "category Yield \n", "chains [Avalanche] \n", "module louverture/index.js \n", "twitter Louverture_fi \n", "audit_links NaN \n", "oracles NaN \n", "slug louverture \n", "tvl 0 \n", "chainTvls {'Avalanche-staking': 13144900.117367093, 'Ava... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 13144900.117367 \n", "fdv 5859185 \n", "mcap 0 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt 1640691832 \n", "audit NaN \n", "audits_link NaN \n", "\n", " kawaiiswap \\\n", "id 1128 \n", "name KawaiiSwap \n", "address bsc:0x9e236b43D779B385c3279820e322ABAE249D3405 \n", "symbol CALCIFIRE \n", "url https://www.kawaiiswap.finance/ \n", "description KawaiiSwap enrichs traditional yield farming e... \n", "chain Binance \n", "logo https://icons.llama.fi/kawaiiswap.png \n", "audits 2 \n", "audit_note None \n", "gecko_id None \n", "cmcId None \n", "category Yield \n", "chains [Binance] \n", "module kawaiiswap-finance/index.js \n", "twitter kawaiiswap \n", "audit_links [https://github.com/solidproof/smart-contract-... \n", "oracles NaN \n", "slug kawaiiswap \n", "tvl 0 \n", "chainTvls {'Binance-Masterchef': 0, 'pool2': 26024.31075... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 78995.659956 \n", "fdv NaN \n", "mcap NaN \n", "pool2 26024.310759 \n", "forkedFrom NaN \n", "listedAt 1640719202 \n", "audit NaN \n", "audits_link NaN \n", "\n", " valkyrie \\\n", "id 1138 \n", "name Valkyrie \n", "address terra:terra1dy9kmlm4anr92e42mrkjwzyvfqwz66un00... \n", "symbol VKR \n", "url https://valkyrieprotocol.com \n", "description Valkyrie Protocol is a DApp activation protoco... \n", "chain Terra \n", "logo https://icons.llama.fi/valkyrie.png \n", "audits 2 \n", "audit_note None \n", "gecko_id valkyrie-protocol \n", "cmcId 12978 \n", "category Staking \n", "chains [Terra] \n", "module valkyrie/index.js \n", "twitter valkyrie_money \n", "audit_links [https://docs.valkyrieprotocol.com/security#au... \n", "oracles NaN \n", "slug valkyrie \n", "tvl 0 \n", "chainTvls {'Terra-staking': 12147179.037418013, 'pool2':... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 12147179.037418 \n", "fdv 347384197 \n", "mcap 29880326 \n", "pool2 12264447.932148 \n", "forkedFrom NaN \n", "listedAt 1640738674 \n", "audit NaN \n", "audits_link NaN \n", "\n", " umbrella-network \\\n", "id 1153 \n", "name Umbrella Network \n", "address 0x6fC13EACE26590B80cCCAB1ba5d51890577D83B2 \n", "symbol UMB \n", "url https://staking.umb.network \n", "description Umbrella is the first truly decentralized orac... \n", "chain Multi-Chain \n", "logo https://icons.llama.fi/umbrella-network.jpg \n", "audits 0 \n", "audit_note None \n", "gecko_id umbrella-network \n", "cmcId 8385 \n", "category Staking \n", "chains [Binance, Ethereum] \n", "module umbrella/index.js \n", "twitter UmbNetwork \n", "audit_links NaN \n", "oracles NaN \n", "slug umbrella-network \n", "tvl 0 \n", "chainTvls {'Binance-staking': 1739.42715, 'pool2': 23718... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 14885084.193486 \n", "fdv 134599735 \n", "mcap 32781061 \n", "pool2 2371866.839791 \n", "forkedFrom NaN \n", "listedAt 1640829115 \n", "audit NaN \n", "audits_link NaN \n", "\n", " cyclos \n", "id 1156 \n", "name Cyclos \n", "address solana:BRLsMczKuaR5w9vSubF4j8HwEGGprVAyyVgS4EX... \n", "symbol CYS \n", "url https://cyclos.io \n", "description The 1st concentrated liquidity market maker on... \n", "chain Solana \n", "logo https://icons.llama.fi/cyclos.png \n", "audits 0 \n", "audit_note None \n", "gecko_id cyclos \n", "cmcId 10217 \n", "category Dexes \n", "chains [Solana] \n", "module cyclos/index.js \n", "twitter cyclosfi \n", "audit_links NaN \n", "oracles NaN \n", "slug cyclos \n", "tvl 0 \n", "chainTvls {'Solana-staking': 1573970.9193507198, 'Solana... \n", "change_1h None \n", "change_1d None \n", "change_7d None \n", "staking 1573970.919351 \n", "fdv 95370304 \n", "mcap 11093474 \n", "pool2 NaN \n", "forkedFrom NaN \n", "listedAt 1640830327 \n", "audit NaN \n", "audits_link NaN \n", "\n", "[32 rows x 1033 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols = dl.get_protocols()\n", "protocols" ] }, { "cell_type": "code", "execution_count": 3, "id": "2442991d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "curve Curve\n", "convex-finance Convex Finance\n", "makerdao MakerDAO\n", "aave AAVE\n", "polygon-bridge-&-staking Polygon Bridge & Staking\n", " ... \n", "louverture Louverture\n", "kawaiiswap KawaiiSwap\n", "valkyrie Valkyrie\n", "umbrella-network Umbrella Network\n", "cyclos Cyclos\n", "Name: name, Length: 1033, dtype: object" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols.loc['name']" ] }, { "cell_type": "code", "execution_count": null, "id": "76b66dc2", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.6" } }, "nbformat": 4, "nbformat_minor": 5 }